JSP+Servlet实现一个简单的带有增删改查的学生信息管理系统

您所在的位置：网站首页 › HTML css js 班级网页增删查改 › JSP+Servlet实现一个简单的带有增删改查的学生信息管理系统

JSP+Servlet实现一个简单的带有增删改查的学生信息管理系统

2024-07-05 08:41| 来源: 网络整理| 查看: 265

项目准备

导入相关Jar包 Jar包将三个Jar包复制到项目的lib目录下，右击添加至构建路径下载链接：jstl.jar，standard.jar，mysql-connector-java-8.0.16.jar,数据库版本5.0需要使用mysql-connector-java-5.1.39-bin.jar

第一步：创建数据库根据实际情况创建数据库表

student.stu stuNo:学号，字符串类型，作为主键； name:学生姓名，字符串类型； sex：性别，字符串类型; birthday：出生日期，date类型; introduce：个人简介，text长文本类型； salary:奖学金，int类型；

第二步：创建实体类根据数据库建的stu表，创建实体类，成员变量类型尽量统一或易转换 package model; public class Student { private String stuNo; private String name; private String sex; private String birthday; private String introduce; private int salary; public String getStuNo() { return stuNo; } public void setStuNo(String stuNo) { this.stuNo = stuNo; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getBirthday() { return birthday; } public void setBirthday(String birthday) { this.birthday = birthday; } public String getIntroduce() { return introduce; } public void setIntroduce(String introduce) { this.introduce = introduce; } public int getSalary() { return salary; } public void setSalary(int salary) { this.salary = salary; } } 第三步：Dao实现对Student类的CRUD(增删改查)方法

数据库工具类：Util.java

package dao; import java.sql.*; public class Util { private static String DRIVER="com.mysql.cj.jdbc.Driver";//数据库连接jar包5.0是com.mysql.jdbc.Driver，此为8.0的驱动路径 private static String URL="jdbc:mysql://localhost:3306/student?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&autoReconnect=true"; //指定连接的数据库以及连接属性设置 private static String USERNAME="root";//用户名 private static String PWD="password";//密码 public static Connection getConnection() throws ClassNotFoundException, SQLException { //获得连接 Connection connection=null; Class.forName(DRIVER); connection=DriverManager.getConnection(URL, USERNAME, PWD); return connection; } public static void closeAll(Connection connection,Statement statement,ResultSet resultSet) throws SQLException { //关闭连接 if(connection!=null) connection.close(); if(statement!=null) statement.close(); if(resultSet!=null) resultSet.close(); } public static void closeAll(Connection connection,Statement statement) throws SQLException { //关闭连接 if(connection!=null) connection.close(); if(statement!=null) statement.close(); } }

具体实现:StudentDao.java

package dao; import java.sql.*; import java.util.Vector; import model.Student; public class StudentDao extends Util{ //返回所有学生的集合 public static Vector getAllStudent() throws ClassNotFoundException, SQLException { Vector students=new Vector(); Connection connection=getConnection(); Statement statement=connection.createStatement(); ResultSet resultSet=statement.executeQuery("select * from stu"); while(resultSet.next()) { Student student=new Student(); student.setStuNo(resultSet.getString(1)); student.setName(resultSet.getString(2)); student.setSex(resultSet.getString(3)); student.setBirthday(resultSet.getString(4)); student.setIntroduce(resultSet.getString(5)); student.setSalary(resultSet.getInt(6)); students.add(student); } closeAll(connection, statement,resultSet); return students; } //通过学号查询并返回某个学生 public static Student getOneStudent(String id) throws ClassNotFoundException, SQLException { Student student=null; Connection connection=getConnection(); PreparedStatement statement=connection.prepareStatement("select * from stu where stuNo=?"); statement.setString(1, id); ResultSet resultSet=statement.executeQuery(); while(resultSet.next()) { student=new Student(); student.setStuNo(resultSet.getString(1)); student.setName(resultSet.g

【本文地址】

JSP+Servlet实现一个简单的带有增删改查的学生信息管理系统

JSP+Servlet实现一个简单的带有增删改查的学生信息管理系统

今日新闻

推荐新闻